
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spCatalogsGetByName]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spCatalogsGetByName]
GO


CREATE PROCEDURE spCatalogsGetByName
	@CatalogName nvarchar(50)
AS

SELECT
	[CatalogID],
	[CatalogName],
	[CatalogOrder]
FROM
	[Catalogs]
WHERE
	[CatalogName] = @CatalogName

GO
	

	
